
truncate table routage
go
BULK 
INSERT routage
        FROM 'c:\famchem.txt'
            WITH
    (
                FIELDTERMINATOR = '; ',
                ROWTERMINATOR = '\n'
    )
GO

select *
  from routage

update routage
	set section = null
 where section = '--'